Display numbers as postal codes, Social Security numbers, or phone numbers

1. Select the cells you want to format.
2. On the Format menu, click Cells, and then click the Number tab.
3. In the Category list, click Special, and then select the format you want to use.

Notes

• If a range of cells contains both five-digit and nine-digit ZIP Codes, you can apply a custom format that displays both types of ZIP Codes correctly. In the Category list, click Custom, and then type the following in the Type box:

  [<=99999]00000;00000-0000

• If you don’t find what you’re looking for, you can create a custom number format.